In order to read or write to Microsoft Access with AlphaDAO functions, you must have permission to read the database's System Catalog.

Tips on working with Microsoft Excel using AlphaDAO connections

Tips on creating databases, creating SQL queries using Alpha Anywhere's Portable SQL Syntax, using the SQL command window, and more.

Tables, sets, and workspaces are the primary structures for storing data in an Alpha Anywhere desktop applications. Your workspace files keep track of all of the tables, sets, toolbars, forms, and such, used for managing information. When you open an existing workspace, Alpha Anywhere displays the objects (tables, forms, etc.) that make up the workspace in the Control Panel. With Alpha Anywhere, you work with one workspace at a time.

When viewing a form or browse, click [x_img] or select Tools > Export to Excel to export the current selection of records to Microsoft Excel. Excel opens, displaying the exported data. Click File > Save As... to save the new spread sheet.

Functions for creating and working with Microsoft Office files.

Reports, Letters, and Labels are Alpha Anywhere layouts for data output. Learn how to create reports in this guide.

Pointer arrays (also called "property arrays") allow you to represent "multi-columned" data in an array. For example, for a customer, you have information about the customer's name, address, phone number etc.

There are 2 different approaches to building a SQL Report.

In this lesson, you learn how to view and enter data in Alpha Anywhere, and how to create, change, save, and delete table records.